package com.iamgod.savemoney.sys;

/**
 * 系统参数
 * @author lihui
 *
 */
public class Config {
	
	/**
	 * 数据库参数
	 * @author lihui
	 *
	 */
	public static final class DataBase{
		/**
		 * 数据库名
		 */
		public static String DATABASE_NAME = "save_money_database";
		/**
		 * 数据库表
		 */
		public static String Table_PlanConfig = "PlanConfig";
		public static String Table_DayPlan = "DayPlan";
		public static String Table_PlanStatements = "PlanStatements";
		/**
		 * 数据库表字段
		 */
		public static String Column_Id = "id";
		public static String Column_PlanName = "planName";
		public static String Column_PlanType = "planType";
		public static String Column_PlanPay = "planPay";
		public static String Column_PlanTime = "planTime";
		public static String Column_ConsumeType = "consumeType";
		public static String Column_ActualPay = "actualPay";
		public static String Column_HasExecuted = "hasExecuted";
		public static String Column_Date = "date";
		public static String Column_Title = "title";
		public static String Column_Type = "type";
		public static String Column_TimeFlag = "timeFlag";
		
		/**
		 * 创建数据表-计划配置表
		 */
		public static String Create_Table_PlanConfig = "create table "+Table_PlanConfig+"(" +
				Column_Id+" integer primary key," +
				Column_PlanName+" varchar(50)," +
				Column_PlanType+" varchar(20)," +
				Column_PlanPay+" varchar(20)," +
				Column_PlanTime+" varchar(20)," +
				Column_ConsumeType+" varchar(20)" +
						")";
		/**
		 * 创建数据表-单日计划表
		 */
		public static String Create_Table_DayPlan = "create table "+Table_DayPlan+"(" +
				Column_Id+" integer primary key," +
				Column_PlanName+" varchar(50)," +
				Column_PlanType+" varchar(20)," +
				Column_PlanPay+" varchar(20)," +
				Column_PlanTime+" varchar(20)," +
				Column_ConsumeType+" varchar(20)" +
				Column_HasExecuted+" varchar(20)," +
				Column_Date+" varchar(20)," +
				Column_ActualPay+" varchar(20)," +
						")";
		
		/**
		 * 创建数据表-计划执行报表
		 */
		public static String Create_Table_PlanStatements = "create table "+Table_PlanStatements+"(" +
				Column_Id+" integer primary key," +
				Column_PlanPay+" varchar(20)," +
				Column_ActualPay+" varchar(20)" +
				Column_TimeFlag+" varchar(20)," +
				Column_Type+" varchar(20)," +
				Column_Title+" varchar(50)," +
						")";
	}

}
